﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_Member') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_Member
END
GO
	Create view V_Member
	as
	Select A.[Guid],A.[MemLoginID],A.[Pwd],A.[Email],A.AdvancePayment,B.Name AS LevelName,A.Score,A.RankScore,A.MemberRankGuid
	FROM [ShopNum1_Member] A LEFT JOIN ShopNum1_MemberRank B ON A.MemberRankGuid=B.Guid
	Where A.IsDeleted = 0 and A.IsForbid = 0 
